Ah, danke!
Apologies for Yithness (man that's harsh!), normal service will resume shortly.
Right - two spreadsheets attached.
I have revised the Eagle one to remove the Che/drop cylinder thing as it seems to be causing confusion. It is more accurately added to Bryansk instead, as the prop is represented by three CiA paid places. This makes it appear as there was a loss at Bryansk but it is noted so one should mentally add £90 to the 'loss' if you need to know whether we broke even, made a loss/profit for that game.
The sheet is made up of three parts:
On the left is a breakdown of income, in the middle is P+L and on the right the balance sheet.
Income list simply adds actual income and passes this through to P+L Income (our 'Sales')
Paypal fees are passed through to P+L Expenses
All game expenses are listed under 'Expenses' regardless of whether they have been paid for or not - this is crutial for Profit and Loss accounts have nothing to do with where money is.
You will see there are two figures missing from expenses but they can be added later with ease, everything will recalculate.
Normally accounts would be presented monthly or quarterly but as we aren't 'normal' our periods are post-game, this is shown by game balances brought forward on the balance sheet. You will see the figures for 'Net Assets' and 'Capital Account' match - they always will and they always have to, if they don't there is a cock-up somewhere!
The balance sheet shows where money is, who is owed money, where money has come from. As payments are made and received figures will change in two places and therefore maintain the 'balance'. For instance, when IED is paid the debt figure will reduce to zero for that line (-£810 becomed £0) but the Paypal figure will drop to reflect that (£854.18 becomes £44.18).
So you see, it doesn't matter whether I have the money or it's is the current account or paypal account - accounts sheets don't have anything to do with you being able to pay Guy (for instance) as that is just an admin matter not an accounting one.
One issue I haven't addressed is one of 'assets'. Some of our expenses are disposable (pyro for instance) and others can be considered capital purchases (ongoing items not used within a game) such as drop cyliders and siren for example. These could be removed from the P+L table and accounted for in the Balance Sheet - we don't need to do anything as complicated as depreciating value over time but it would show a better 'profit' per game as these purchases add to our assest instead of being written off. Anyhoo, a conversation for another day.
why are the drop cylinders not accounted for either from Eagles or Bryan ? 
There the reason the accounts are in the shtcik to start with shirley
Other than that makes sense to me , just get a Capital Assets Register underway and jobs a good un.
Ah, that's because we didn't pay for the cylinders (in reality they appear as £90 we paid to IED). That's why it was confusing!
If you want to have a capital register (accounting for permanent props) then I'll drop a capital slot in the accounts - it will mean moving cash from game P+L to Balance Sheet (i.e. greater 'profit' to each game) but the net effect remains the same to cash we hold obviously.
Since the cash we hold is vital to know I'll put in a separate table that shows 'liquidity' (basically current assets - liabilities). No required from accounting POV but nice to see at a glance.
So we're just keeping the £120 that covered the three places in the cash account on the balance sheet and calling Bryansk a loss of £15.82, even though we all know it's currently running at a profit of £104.18....right?
Aaaaanyway. The formula in the Net Cash line under income seems a little screwed up for me. It's giving a VALUE! return. When I look at the formula it reads: =SUM((IV7+A7+B7)-SUM(C7)) which doesn't make any sense at all. EG: 'A7' is the name of the payee....'IV7' is a cell miles away from anything. Plus it's all formatted in dollars. Is this a PC/Mac thing maybe? Will open on my PC at some point.
S
Heh, that's weird! Some copy and paste crapness creeping in there I think...
Anyhoo, that colum is FIO and doesn't have a part in the accounts per se.
Now corrected but I won't re-post until the capital account is done.
Dave, I just edited my thread whilst you were replying with a question about 'The Missing £120'.
So we're just keeping the £120 that covered the three places in the cash account on the balance sheet and calling Bryansk a loss of £15.82, even though we all know it's currently running at a profit of £104.18....right?
I assume the formula should just be =B7-C7.
Ah, that's because we didn't pay for the cylinders (in reality they appear as £90 we paid to IED). That's why it was confusing!
If you want to have a capital register (accounting for permanent props) then I'll drop a capital slot in the accounts - it will mean moving cash from game P+L to Balance Sheet (i.e. greater 'profit' to each game) but the net effect remains the same to cash we hold obviously.
Since the cash we hold is vital to know I'll put in a separate table that shows 'liquidity' (basically current assets - liabilities). No required from accounting POV but nice to see at a glance.
I'll accept that !, although as a purchasing person it goes against my nature. 
We purchased two containers ...& that transaction is not recorded in a obvious manner ....unimportant as long as we know whats going on .
He ho, though it's all good , & agreed the key issues for us is to see are the free cash available, plus the pyro stock and props we hold .
Now David, on Quickbooks , should I be using the credit card function to record purchase made by my debit card, or the write cheque function. Most of my purchases are not credit supplied, but paid for up front ....? Using the cheque function it appears all my purchases are comning from petty cash rather than bank account ...help
And why can't i raise a purchase order in thenirmal sense , and wheres the stock management option ......questions questions.
Ah, confused over the question now. No, I see the edit.
No, there is no £120 - it's a fictinal amount and has neither been paid by anyone, nor received by anyone - so shouldn't appear in the accounts.
In effect we paid IED £90 for the cylinders (three places x £30 - Che, Carl and Gavin) - at least until I have the capital account sorted, when it will move.
I imagine the dollar substitution is a Mac thing.
Now David, on Quickbooks , should I be using the credit card function to record purchase made by my debit card, or the write cheque function. Most of my purchases are not credit supplied, but paid for up front ....? Using the cheque function it appears all my purchases are comning from petty cash rather than bank account ...help
And why can't i raise a purchase order in thenirmal sense , and wheres the stock management option ......questions questions.
Use cheque account for debit card purchases - you won't be able to reconcile your bank statement otherwise.
I'm not sure about your QB version but when using the Cheques funtion you have a drop-down box at the top to specify which cash account you wan to use - prob by default it's Petty Cash.
Stock Management is prob in another version of QB - I don't use it anyway. Easier for me to do a stock check at year end and manually enter it in Balance sheet - it's only two entrys.
I'm not sure why you would want to raise a PO - I never have done, just click 'order' on the interweb or grab it from a shop!
Now David, on Quickbooks , should I be using the credit card function to record purchase made by my debit card, or the write cheque function. Most of my purchases are not credit supplied, but paid for up front ....? Using the cheque function it appears all my purchases are comning from petty cash rather than bank account ...help
And why can't i raise a purchase order in thenirmal sense , and wheres the stock management option ......questions questions.Use cheque account for debit card purchases - you won't be able to reconcile your bank statement otherwise.
I'm not sure about your QB version but when using the Cheques funtion you have a drop-down box at the top to specify which cash account you wan to use - prob by default it's Petty Cash.
Stock Management is prob in another version of QB - I don't use it anyway. Easier for me to do a stock check at year end and manually enter it in Balance sheet - it's only two entrys.
I'm not sure why you would want to raise a PO - I never have done, just click 'order' on the interweb or grab it from a shop!
Cheers , the PO was a bit tongue in cheeck. for 20 years I've lived by the holy trinity of the three way match ....PO, reciept/booking in ....invoice. It's the life blood of purchasing invoice queries but irrelavent to A2C
The lack of stock management is annoying ...I'm sure if I were running a builders firm the abilty not to book consumables to a job would be annoying. Mind you whatdya expect for £50 !
PS you were right about defaulting to petty cash . 
Ah, confused over the question now. No, I see the edit.
No, there is no £120 - it's a fictinal amount and has neither been paid by anyone, nor received by anyone - so shouldn't appear in the accounts.
In effect we paid IED £90 for the cylinders (three places x £30 - Che, Carl and Gavin) - at least until I have the capital account sorted, when it will move.I imagine the dollar substitution is a Mac thing.
OK, but I was working with that amount in the kitty so the game wasn't in loss. Because of the accounting anomoly, or rather idiosyncracy, we are, but in the cash account we still have a good amount of profit, or capital, right?
Have reformatted the spreadsheet with £s now.
S
It will become a bit clearer when the I've done the capital account version. I'll name the liquidity section 'The Kitty' 
- we are in the black overall!
Great - lets buy more explosives ! 
IED now paid! 
Cheers for that , didn't want to turn up for A2C still owing them ,
No, absolutely. Believe it or not, that was the quickest I could have possibly got it sorted! What a faff!!
Anyway, we've now had all the limits lifted off the account.
